<?php
/**
 *	[alias(alias.install)] (C)2012-2099 Powered by abans@qq.com.
 *	Version: 1.0
 *	Date: 2012-10-29 13:21
 */

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}


$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `pre_plugin_alias_bind` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `alias` varchar(100) NOT NULL,
  `rid` int(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`,`type`),
  UNIQUE KEY `rid` (`rid`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1
EOF;

runquery($sql);
$finish = TRUE;

?>